from django.db import models

# Create your models here.
"""
缴费查询表

"""
class CostQuery(models.Model):
    pay_status_choices = (
        ('0','已缴费'),
        ('1','未缴费'),
    )
    # name = models.CharField(max_length=12, verbose_name='姓名', null=False)
    # grade = models.CharField(max_length=32, verbose_name='年级', null=False)
    # the_class = models.CharField(max_length=32, verbose_name='班级', null=False)
    # id_number = models.CharField(max_length=18, verbose_name='身份证号', null=False, unique=True)

    pay_time = models.DateTimeField(auto_now_add=True,verbose_name='缴费期限',null=False)
    pay_type = models.CharField(max_length=12,verbose_name='缴费类型',null=False,)
    pay_lines = models.CharField(max_length=8,verbose_name='缴费金额',null=False,)
    pay_status = models.CharField(max_length=12,verbose_name='缴费状态',choices=pay_status_choices,default=1)
    pay_times = models.DateTimeField(verbose_name='缴费时间',blank=True)


    class Meta:
        db_table = 'cost_query'
        verbose_name = '学生缴费表'
        verbose_name_plural = verbose_name